﻿
------------------------ INSERT ROLES FOR USER1-------------------------------------
GO
IF NOT EXISTS (SELECT UserRoleId FROM UserRole WHERE UserId = 1 AND RoleId = 1)
BEGIN
INSERT INTO UserRole(UserId,RoleId)
     VALUES(1,1)
END

GO
IF NOT EXISTS (SELECT UserRoleId FROM UserRole WHERE UserId = 1 AND RoleId = 2)
BEGIN
INSERT INTO UserRole(UserId,RoleId)
     VALUES(1,2)
END

GO
IF NOT EXISTS (SELECT UserRoleId FROM UserRole WHERE UserId = 1 AND RoleId = 3)
BEGIN
INSERT INTO UserRole(UserId,RoleId)
     VALUES(1,3)
END



